Aggregation example

In the following example, Mike the organization’s data scientist, wants to create an aggregation table that shows the total freight costs per shipping region and product category; for example, the total cost of shipping rice to Australia in 2015.

To achieve this objective, he adds the CategoryName and ShipRegion attributes to the Group By list and then adds the Freight attribute to the Aggregations list. As Mike is interested in the total freight cost, he selects SUM as the Aggregation Type.